← Return to doc.sitecore.com

  Installation Guide for DMS on SQL Server
Print this page (opens in new window) Print

Prerequisites:

Follow the instructions below to install Sitecore DMS:

  1. Download the zip-archive with the DMS for SQL Server from the CMS and DMS Downloads page.
  2. Extract the contents of the zip-archive to a folder on your disk.
  3. On the Database Server, perform the following steps:
    1. Attach the Sitecore.Analytics.mdf database.
      Note: You can create a Database Account with the minimum required permissions for the Analytics database as described in section “Microsoft SQL Server Configuration” of the CMS Installation Guide.
  4. On each Web Server, perform the following steps:
    1. Add the following string in the ConnectionStrings.config file:
      <add name="analytics" connectionString="user id=_username_;password=_password_;Data Source=_server_;Database=Sitecore_Analytics" />
    2. Copy the Sitecore.Analytics.config file and the Sitecore.Analytics.ExlcudeRobots.config file to the /App_Config/Include/ folder.
    3. In Sitecore 7.2 and later, also copy the Sitecore.Analytics.RobotDetection.config file to the /App_Config/Include/ folder.
    4. Update relevant web.config and Sitecore.Analytics.config settings, such as MailServer and Analytics.EMailFromAddress (for sending out reports as emails).
    5. If you wish to use DMS with Sitecore MVC, rename the /App_Config/Include/Sitecore.MvcAnalytics.config.disabled to Sitecore.MvcAnalytics.config.
    6. Modify existing layouts and put in a <sc:VisitorIdentification runat="server"/> Web control in the <head> block to enable automatic robot detection.
      To make this work, you should also add the appropriate namespace definition in each layout and sublayout. This can be done in web.config, for instance:
      <system.web>
         <!-- Continue to run Sitecore without script validations -->
         <pages validateRequest="false">
            <controls>
               <add tagPrefix="sc" namespace="Sitecore.Web.UI.WebControls" assembly="Sitecore.Analytics"/>
      See Engagement Analytics Configuration Reference for more details about relevant settings and the <sc:VisitorIdentification /> web control.
    7. Update the Analytics.PerformLookup setting in the /App_Config/Include/Sitecore.Analytics.config file to limit the lookup activity to one server.
      Note: You can enable lookups on either a CM or a CD instance. The Sitecore instance should be able to access the MaxMind web service.
      See MaxMind Signup and Purchase for more details about GeoIP lookup functionality.
    8. Restart Internet Information Services (IIS).

The Sitecore DMS is now configured properly.

Notice: If you have upgraded your solution from CMS 6.0, please check if the following 3 roles exist: "sitecore\Analytics Content Profiling", "sitecore\Analytics Maintaining", "sitecore\Analytics Reporting". If the roles do not exist, please manually create them or install the following package: Sitecore Analytics Roles (Sitecore CMS package, 25 Kb)